﻿CREATE TABLE [dbo].[UDS_CM_ClientInfo] (
    [ID]                int           NOT NULL identity(1, 1),
    [ChiefLinkmanID]    int           NULL,
    [Birthday]          datetime      NULL,
    [UpdateTime]        datetime      NULL,
    [Name]              nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
    [ShortName]         nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
    [ContactTimes]      int           NULL CONSTRAINT [DF_UDS_CM_ClientInfo_ContactTimes] default(((0))),
    [SellPhase]         nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
    [BargainPrognosis]  nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
    [Fee]               int           NULL,
    [AddManID]          int           NULL,
    [Linkman_Telephone] nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
    [CurStatus]         nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
    [Type]              nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
    [Affiliatedarea]    nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
    [URL]               nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
    [ZIP]               nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
    [Address]           nvarchar(200)  COLLATE Chinese_PRC_CI_AS NULL,
    [CompanyProperty]   nvarchar(200)  COLLATE Chinese_PRC_CI_AS NULL,
    [Calling]           nvarchar(2000) COLLATE Chinese_PRC_CI_AS NULL,
    [CompanySize]       nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
    [Money]             nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
    [Operation]         nvarchar(200)  COLLATE Chinese_PRC_CI_AS NULL,
    [Introduce]         nvarchar(1000) COLLATE Chinese_PRC_CI_AS NULL,
    [ITGrade]           nvarchar(1000) COLLATE Chinese_PRC_CI_AS NULL,
    [PCNumber]          nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
    [Net]               nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
    [ITStaffs]          int           NULL,
    [ITDepartment]      nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
    [Principal]         nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
    [System]            nvarchar(1000) COLLATE Chinese_PRC_CI_AS NULL,
    [Customer]          nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
    [ClientInitiative]  nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
    [FirstContactTime]  datetime      NULL,
    [NextContactTime]   datetime      NULL,
    [ContactTime]       datetime      NULL,

    CONSTRAINT [PK_UDS_CM_ClientInfo] PRIMARY KEY CLUSTERED ([ID] asc)
);
GO
